package com.tgc.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class TgcB2CSubOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TgcB2CSubOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNull() {
            addCriterion("ORDERID_ is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("ORDERID_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(String value) {
            addCriterion("ORDERID_ =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(String value) {
            addCriterion("ORDERID_ <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(String value) {
            addCriterion("ORDERID_ >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERID_ >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(String value) {
            addCriterion("ORDERID_ <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(String value) {
            addCriterion("ORDERID_ <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLike(String value) {
            addCriterion("ORDERID_ like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotLike(String value) {
            addCriterion("ORDERID_ not like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<String> values) {
            addCriterion("ORDERID_ in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<String> values) {
            addCriterion("ORDERID_ not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(String value1, String value2) {
            addCriterion("ORDERID_ between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(String value1, String value2) {
            addCriterion("ORDERID_ not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrdernameIsNull() {
            addCriterion("ORDERNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andOrdernameIsNotNull() {
            addCriterion("ORDERNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernameEqualTo(String value) {
            addCriterion("ORDERNAME_ =", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameNotEqualTo(String value) {
            addCriterion("ORDERNAME_ <>", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameGreaterThan(String value) {
            addCriterion("ORDERNAME_ >", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERNAME_ >=", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameLessThan(String value) {
            addCriterion("ORDERNAME_ <", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameLessThanOrEqualTo(String value) {
            addCriterion("ORDERNAME_ <=", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameLike(String value) {
            addCriterion("ORDERNAME_ like", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameNotLike(String value) {
            addCriterion("ORDERNAME_ not like", value, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameIn(List<String> values) {
            addCriterion("ORDERNAME_ in", values, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameNotIn(List<String> values) {
            addCriterion("ORDERNAME_ not in", values, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameBetween(String value1, String value2) {
            addCriterion("ORDERNAME_ between", value1, value2, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrdernameNotBetween(String value1, String value2) {
            addCriterion("ORDERNAME_ not between", value1, value2, "ordername");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidIsNull() {
            addCriterion("ORDERDELIVERYINFOID_ is null");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidIsNotNull() {
            addCriterion("ORDERDELIVERYINFOID_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidEqualTo(String value) {
            addCriterion("ORDERDELIVERYINFOID_ =", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidNotEqualTo(String value) {
            addCriterion("ORDERDELIVERYINFOID_ <>", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidGreaterThan(String value) {
            addCriterion("ORDERDELIVERYINFOID_ >", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERDELIVERYINFOID_ >=", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidLessThan(String value) {
            addCriterion("ORDERDELIVERYINFOID_ <", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidLessThanOrEqualTo(String value) {
            addCriterion("ORDERDELIVERYINFOID_ <=", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidLike(String value) {
            addCriterion("ORDERDELIVERYINFOID_ like", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidNotLike(String value) {
            addCriterion("ORDERDELIVERYINFOID_ not like", value, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidIn(List<String> values) {
            addCriterion("ORDERDELIVERYINFOID_ in", values, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidNotIn(List<String> values) {
            addCriterion("ORDERDELIVERYINFOID_ not in", values, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidBetween(String value1, String value2) {
            addCriterion("ORDERDELIVERYINFOID_ between", value1, value2, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andOrderdeliveryinfoidNotBetween(String value1, String value2) {
            addCriterion("ORDERDELIVERYINFOID_ not between", value1, value2, "orderdeliveryinfoid");
            return (Criteria) this;
        }

        public Criteria andPointsIsNull() {
            addCriterion("POINTS_ is null");
            return (Criteria) this;
        }

        public Criteria andPointsIsNotNull() {
            addCriterion("POINTS_ is not null");
            return (Criteria) this;
        }

        public Criteria andPointsEqualTo(BigDecimal value) {
            addCriterion("POINTS_ =", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsNotEqualTo(BigDecimal value) {
            addCriterion("POINTS_ <>", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsGreaterThan(BigDecimal value) {
            addCriterion("POINTS_ >", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("POINTS_ >=", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsLessThan(BigDecimal value) {
            addCriterion("POINTS_ <", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("POINTS_ <=", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsIn(List<BigDecimal> values) {
            addCriterion("POINTS_ in", values, "points");
            return (Criteria) this;
        }

        public Criteria andPointsNotIn(List<BigDecimal> values) {
            addCriterion("POINTS_ not in", values, "points");
            return (Criteria) this;
        }

        public Criteria andPointsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("POINTS_ between", value1, value2, "points");
            return (Criteria) this;
        }

        public Criteria andPointsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("POINTS_ not between", value1, value2, "points");
            return (Criteria) this;
        }

        public Criteria andPreferentialIsNull() {
            addCriterion("PREFERENTIAL_ is null");
            return (Criteria) this;
        }

        public Criteria andPreferentialIsNotNull() {
            addCriterion("PREFERENTIAL_ is not null");
            return (Criteria) this;
        }

        public Criteria andPreferentialEqualTo(String value) {
            addCriterion("PREFERENTIAL_ =", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotEqualTo(String value) {
            addCriterion("PREFERENTIAL_ <>", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialGreaterThan(String value) {
            addCriterion("PREFERENTIAL_ >", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialGreaterThanOrEqualTo(String value) {
            addCriterion("PREFERENTIAL_ >=", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialLessThan(String value) {
            addCriterion("PREFERENTIAL_ <", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialLessThanOrEqualTo(String value) {
            addCriterion("PREFERENTIAL_ <=", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialLike(String value) {
            addCriterion("PREFERENTIAL_ like", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotLike(String value) {
            addCriterion("PREFERENTIAL_ not like", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialIn(List<String> values) {
            addCriterion("PREFERENTIAL_ in", values, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotIn(List<String> values) {
            addCriterion("PREFERENTIAL_ not in", values, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialBetween(String value1, String value2) {
            addCriterion("PREFERENTIAL_ between", value1, value2, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotBetween(String value1, String value2) {
            addCriterion("PREFERENTIAL_ not between", value1, value2, "preferential");
            return (Criteria) this;
        }

        public Criteria andSubtotalIsNull() {
            addCriterion("SUBTOTAL_ is null");
            return (Criteria) this;
        }

        public Criteria andSubtotalIsNotNull() {
            addCriterion("SUBTOTAL_ is not null");
            return (Criteria) this;
        }

        public Criteria andSubtotalEqualTo(BigDecimal value) {
            addCriterion("SUBTOTAL_ =", value, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalNotEqualTo(BigDecimal value) {
            addCriterion("SUBTOTAL_ <>", value, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalGreaterThan(BigDecimal value) {
            addCriterion("SUBTOTAL_ >", value, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SUBTOTAL_ >=", value, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalLessThan(BigDecimal value) {
            addCriterion("SUBTOTAL_ <", value, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SUBTOTAL_ <=", value, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalIn(List<BigDecimal> values) {
            addCriterion("SUBTOTAL_ in", values, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalNotIn(List<BigDecimal> values) {
            addCriterion("SUBTOTAL_ not in", values, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUBTOTAL_ between", value1, value2, "subtotal");
            return (Criteria) this;
        }

        public Criteria andSubtotalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUBTOTAL_ not between", value1, value2, "subtotal");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("NOTE_ is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("NOTE_ is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("NOTE_ =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("NOTE_ <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("NOTE_ >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("NOTE_ >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("NOTE_ <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("NOTE_ <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("NOTE_ like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("NOTE_ not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("NOTE_ in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("NOTE_ not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("NOTE_ between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("NOTE_ not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS_ is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS_ is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS_ =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS_ <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS_ >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS_ >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS_ <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS_ <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS_ like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS_ not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS_ in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS_ not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS_ between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS_ not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDowntimeIsNull() {
            addCriterion("DOWNTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andDowntimeIsNotNull() {
            addCriterion("DOWNTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andDowntimeEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ =", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeNotEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ <>", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeGreaterThan(BigDecimal value) {
            addCriterion("DOWNTIME_ >", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ >=", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeLessThan(BigDecimal value) {
            addCriterion("DOWNTIME_ <", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNTIME_ <=", value, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeIn(List<BigDecimal> values) {
            addCriterion("DOWNTIME_ in", values, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeNotIn(List<BigDecimal> values) {
            addCriterion("DOWNTIME_ not in", values, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNTIME_ between", value1, value2, "downtime");
            return (Criteria) this;
        }

        public Criteria andDowntimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNTIME_ not between", value1, value2, "downtime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeIsNull() {
            addCriterion("STRDOWNTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeIsNotNull() {
            addCriterion("STRDOWNTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeEqualTo(String value) {
            addCriterion("STRDOWNTIME_ =", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeNotEqualTo(String value) {
            addCriterion("STRDOWNTIME_ <>", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeGreaterThan(String value) {
            addCriterion("STRDOWNTIME_ >", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeGreaterThanOrEqualTo(String value) {
            addCriterion("STRDOWNTIME_ >=", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeLessThan(String value) {
            addCriterion("STRDOWNTIME_ <", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeLessThanOrEqualTo(String value) {
            addCriterion("STRDOWNTIME_ <=", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeLike(String value) {
            addCriterion("STRDOWNTIME_ like", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeNotLike(String value) {
            addCriterion("STRDOWNTIME_ not like", value, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeIn(List<String> values) {
            addCriterion("STRDOWNTIME_ in", values, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeNotIn(List<String> values) {
            addCriterion("STRDOWNTIME_ not in", values, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeBetween(String value1, String value2) {
            addCriterion("STRDOWNTIME_ between", value1, value2, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andStrdowntimeNotBetween(String value1, String value2) {
            addCriterion("STRDOWNTIME_ not between", value1, value2, "strdowntime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UPDATETIME_ is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UPDATETIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(BigDecimal value) {
            addCriterion("UPDATETIME_ >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(BigDecimal value) {
            addCriterion("UPDATETIME_ <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UPDATETIME_ <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<BigDecimal> values) {
            addCriterion("UPDATETIME_ in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<BigDecimal> values) {
            addCriterion("UPDATETIME_ not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPDATETIME_ between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPDATETIME_ not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeIsNull() {
            addCriterion("STRUPDATETIME_ is null");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeIsNotNull() {
            addCriterion("STRUPDATETIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeEqualTo(String value) {
            addCriterion("STRUPDATETIME_ =", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeNotEqualTo(String value) {
            addCriterion("STRUPDATETIME_ <>", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeGreaterThan(String value) {
            addCriterion("STRUPDATETIME_ >", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeGreaterThanOrEqualTo(String value) {
            addCriterion("STRUPDATETIME_ >=", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeLessThan(String value) {
            addCriterion("STRUPDATETIME_ <", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeLessThanOrEqualTo(String value) {
            addCriterion("STRUPDATETIME_ <=", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeLike(String value) {
            addCriterion("STRUPDATETIME_ like", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeNotLike(String value) {
            addCriterion("STRUPDATETIME_ not like", value, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeIn(List<String> values) {
            addCriterion("STRUPDATETIME_ in", values, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeNotIn(List<String> values) {
            addCriterion("STRUPDATETIME_ not in", values, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeBetween(String value1, String value2) {
            addCriterion("STRUPDATETIME_ between", value1, value2, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andStrupdatetimeNotBetween(String value1, String value2) {
            addCriterion("STRUPDATETIME_ not between", value1, value2, "strupdatetime");
            return (Criteria) this;
        }

        public Criteria andAttri1IsNull() {
            addCriterion("ATTRI1_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri1IsNotNull() {
            addCriterion("ATTRI1_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri1EqualTo(String value) {
            addCriterion("ATTRI1_ =", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1NotEqualTo(String value) {
            addCriterion("ATTRI1_ <>", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1GreaterThan(String value) {
            addCriterion("ATTRI1_ >", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI1_ >=", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1LessThan(String value) {
            addCriterion("ATTRI1_ <", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1LessThanOrEqualTo(String value) {
            addCriterion("ATTRI1_ <=", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1Like(String value) {
            addCriterion("ATTRI1_ like", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1NotLike(String value) {
            addCriterion("ATTRI1_ not like", value, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1In(List<String> values) {
            addCriterion("ATTRI1_ in", values, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1NotIn(List<String> values) {
            addCriterion("ATTRI1_ not in", values, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1Between(String value1, String value2) {
            addCriterion("ATTRI1_ between", value1, value2, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri1NotBetween(String value1, String value2) {
            addCriterion("ATTRI1_ not between", value1, value2, "attri1");
            return (Criteria) this;
        }

        public Criteria andAttri2IsNull() {
            addCriterion("ATTRI2_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri2IsNotNull() {
            addCriterion("ATTRI2_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri2EqualTo(String value) {
            addCriterion("ATTRI2_ =", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2NotEqualTo(String value) {
            addCriterion("ATTRI2_ <>", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2GreaterThan(String value) {
            addCriterion("ATTRI2_ >", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI2_ >=", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2LessThan(String value) {
            addCriterion("ATTRI2_ <", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2LessThanOrEqualTo(String value) {
            addCriterion("ATTRI2_ <=", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2Like(String value) {
            addCriterion("ATTRI2_ like", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2NotLike(String value) {
            addCriterion("ATTRI2_ not like", value, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2In(List<String> values) {
            addCriterion("ATTRI2_ in", values, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2NotIn(List<String> values) {
            addCriterion("ATTRI2_ not in", values, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2Between(String value1, String value2) {
            addCriterion("ATTRI2_ between", value1, value2, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri2NotBetween(String value1, String value2) {
            addCriterion("ATTRI2_ not between", value1, value2, "attri2");
            return (Criteria) this;
        }

        public Criteria andAttri3IsNull() {
            addCriterion("ATTRI3_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri3IsNotNull() {
            addCriterion("ATTRI3_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri3EqualTo(String value) {
            addCriterion("ATTRI3_ =", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3NotEqualTo(String value) {
            addCriterion("ATTRI3_ <>", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3GreaterThan(String value) {
            addCriterion("ATTRI3_ >", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI3_ >=", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3LessThan(String value) {
            addCriterion("ATTRI3_ <", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3LessThanOrEqualTo(String value) {
            addCriterion("ATTRI3_ <=", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3Like(String value) {
            addCriterion("ATTRI3_ like", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3NotLike(String value) {
            addCriterion("ATTRI3_ not like", value, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3In(List<String> values) {
            addCriterion("ATTRI3_ in", values, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3NotIn(List<String> values) {
            addCriterion("ATTRI3_ not in", values, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3Between(String value1, String value2) {
            addCriterion("ATTRI3_ between", value1, value2, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri3NotBetween(String value1, String value2) {
            addCriterion("ATTRI3_ not between", value1, value2, "attri3");
            return (Criteria) this;
        }

        public Criteria andAttri4IsNull() {
            addCriterion("ATTRI4_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri4IsNotNull() {
            addCriterion("ATTRI4_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri4EqualTo(String value) {
            addCriterion("ATTRI4_ =", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4NotEqualTo(String value) {
            addCriterion("ATTRI4_ <>", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4GreaterThan(String value) {
            addCriterion("ATTRI4_ >", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI4_ >=", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4LessThan(String value) {
            addCriterion("ATTRI4_ <", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4LessThanOrEqualTo(String value) {
            addCriterion("ATTRI4_ <=", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4Like(String value) {
            addCriterion("ATTRI4_ like", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4NotLike(String value) {
            addCriterion("ATTRI4_ not like", value, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4In(List<String> values) {
            addCriterion("ATTRI4_ in", values, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4NotIn(List<String> values) {
            addCriterion("ATTRI4_ not in", values, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4Between(String value1, String value2) {
            addCriterion("ATTRI4_ between", value1, value2, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri4NotBetween(String value1, String value2) {
            addCriterion("ATTRI4_ not between", value1, value2, "attri4");
            return (Criteria) this;
        }

        public Criteria andAttri5IsNull() {
            addCriterion("ATTRI5_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri5IsNotNull() {
            addCriterion("ATTRI5_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri5EqualTo(String value) {
            addCriterion("ATTRI5_ =", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5NotEqualTo(String value) {
            addCriterion("ATTRI5_ <>", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5GreaterThan(String value) {
            addCriterion("ATTRI5_ >", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI5_ >=", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5LessThan(String value) {
            addCriterion("ATTRI5_ <", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5LessThanOrEqualTo(String value) {
            addCriterion("ATTRI5_ <=", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5Like(String value) {
            addCriterion("ATTRI5_ like", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5NotLike(String value) {
            addCriterion("ATTRI5_ not like", value, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5In(List<String> values) {
            addCriterion("ATTRI5_ in", values, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5NotIn(List<String> values) {
            addCriterion("ATTRI5_ not in", values, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5Between(String value1, String value2) {
            addCriterion("ATTRI5_ between", value1, value2, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri5NotBetween(String value1, String value2) {
            addCriterion("ATTRI5_ not between", value1, value2, "attri5");
            return (Criteria) this;
        }

        public Criteria andAttri6IsNull() {
            addCriterion("ATTRI6_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri6IsNotNull() {
            addCriterion("ATTRI6_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri6EqualTo(String value) {
            addCriterion("ATTRI6_ =", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6NotEqualTo(String value) {
            addCriterion("ATTRI6_ <>", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6GreaterThan(String value) {
            addCriterion("ATTRI6_ >", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI6_ >=", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6LessThan(String value) {
            addCriterion("ATTRI6_ <", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6LessThanOrEqualTo(String value) {
            addCriterion("ATTRI6_ <=", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6Like(String value) {
            addCriterion("ATTRI6_ like", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6NotLike(String value) {
            addCriterion("ATTRI6_ not like", value, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6In(List<String> values) {
            addCriterion("ATTRI6_ in", values, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6NotIn(List<String> values) {
            addCriterion("ATTRI6_ not in", values, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6Between(String value1, String value2) {
            addCriterion("ATTRI6_ between", value1, value2, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri6NotBetween(String value1, String value2) {
            addCriterion("ATTRI6_ not between", value1, value2, "attri6");
            return (Criteria) this;
        }

        public Criteria andAttri7IsNull() {
            addCriterion("ATTRI7_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri7IsNotNull() {
            addCriterion("ATTRI7_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri7EqualTo(String value) {
            addCriterion("ATTRI7_ =", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7NotEqualTo(String value) {
            addCriterion("ATTRI7_ <>", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7GreaterThan(String value) {
            addCriterion("ATTRI7_ >", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI7_ >=", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7LessThan(String value) {
            addCriterion("ATTRI7_ <", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7LessThanOrEqualTo(String value) {
            addCriterion("ATTRI7_ <=", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7Like(String value) {
            addCriterion("ATTRI7_ like", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7NotLike(String value) {
            addCriterion("ATTRI7_ not like", value, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7In(List<String> values) {
            addCriterion("ATTRI7_ in", values, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7NotIn(List<String> values) {
            addCriterion("ATTRI7_ not in", values, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7Between(String value1, String value2) {
            addCriterion("ATTRI7_ between", value1, value2, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri7NotBetween(String value1, String value2) {
            addCriterion("ATTRI7_ not between", value1, value2, "attri7");
            return (Criteria) this;
        }

        public Criteria andAttri8IsNull() {
            addCriterion("ATTRI8_ is null");
            return (Criteria) this;
        }

        public Criteria andAttri8IsNotNull() {
            addCriterion("ATTRI8_ is not null");
            return (Criteria) this;
        }

        public Criteria andAttri8EqualTo(String value) {
            addCriterion("ATTRI8_ =", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8NotEqualTo(String value) {
            addCriterion("ATTRI8_ <>", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8GreaterThan(String value) {
            addCriterion("ATTRI8_ >", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8GreaterThanOrEqualTo(String value) {
            addCriterion("ATTRI8_ >=", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8LessThan(String value) {
            addCriterion("ATTRI8_ <", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8LessThanOrEqualTo(String value) {
            addCriterion("ATTRI8_ <=", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8Like(String value) {
            addCriterion("ATTRI8_ like", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8NotLike(String value) {
            addCriterion("ATTRI8_ not like", value, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8In(List<String> values) {
            addCriterion("ATTRI8_ in", values, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8NotIn(List<String> values) {
            addCriterion("ATTRI8_ not in", values, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8Between(String value1, String value2) {
            addCriterion("ATTRI8_ between", value1, value2, "attri8");
            return (Criteria) this;
        }

        public Criteria andAttri8NotBetween(String value1, String value2) {
            addCriterion("ATTRI8_ not between", value1, value2, "attri8");
            return (Criteria) this;
        }

        public Criteria andCartidIsNull() {
            addCriterion("CARTID_ is null");
            return (Criteria) this;
        }

        public Criteria andCartidIsNotNull() {
            addCriterion("CARTID_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartidEqualTo(String value) {
            addCriterion("CARTID_ =", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidNotEqualTo(String value) {
            addCriterion("CARTID_ <>", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidGreaterThan(String value) {
            addCriterion("CARTID_ >", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidGreaterThanOrEqualTo(String value) {
            addCriterion("CARTID_ >=", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidLessThan(String value) {
            addCriterion("CARTID_ <", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidLessThanOrEqualTo(String value) {
            addCriterion("CARTID_ <=", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidLike(String value) {
            addCriterion("CARTID_ like", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidNotLike(String value) {
            addCriterion("CARTID_ not like", value, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidIn(List<String> values) {
            addCriterion("CARTID_ in", values, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidNotIn(List<String> values) {
            addCriterion("CARTID_ not in", values, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidBetween(String value1, String value2) {
            addCriterion("CARTID_ between", value1, value2, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartidNotBetween(String value1, String value2) {
            addCriterion("CARTID_ not between", value1, value2, "cartid");
            return (Criteria) this;
        }

        public Criteria andCartproductidIsNull() {
            addCriterion("CARTPRODUCTID_ is null");
            return (Criteria) this;
        }

        public Criteria andCartproductidIsNotNull() {
            addCriterion("CARTPRODUCTID_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartproductidEqualTo(String value) {
            addCriterion("CARTPRODUCTID_ =", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidNotEqualTo(String value) {
            addCriterion("CARTPRODUCTID_ <>", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidGreaterThan(String value) {
            addCriterion("CARTPRODUCTID_ >", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidGreaterThanOrEqualTo(String value) {
            addCriterion("CARTPRODUCTID_ >=", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidLessThan(String value) {
            addCriterion("CARTPRODUCTID_ <", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidLessThanOrEqualTo(String value) {
            addCriterion("CARTPRODUCTID_ <=", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidLike(String value) {
            addCriterion("CARTPRODUCTID_ like", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidNotLike(String value) {
            addCriterion("CARTPRODUCTID_ not like", value, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidIn(List<String> values) {
            addCriterion("CARTPRODUCTID_ in", values, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidNotIn(List<String> values) {
            addCriterion("CARTPRODUCTID_ not in", values, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidBetween(String value1, String value2) {
            addCriterion("CARTPRODUCTID_ between", value1, value2, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartproductidNotBetween(String value1, String value2) {
            addCriterion("CARTPRODUCTID_ not between", value1, value2, "cartproductid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidIsNull() {
            addCriterion("CARTCOMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidIsNotNull() {
            addCriterion("CARTCOMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidEqualTo(String value) {
            addCriterion("CARTCOMPANYID_ =", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidNotEqualTo(String value) {
            addCriterion("CARTCOMPANYID_ <>", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidGreaterThan(String value) {
            addCriterion("CARTCOMPANYID_ >", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("CARTCOMPANYID_ >=", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidLessThan(String value) {
            addCriterion("CARTCOMPANYID_ <", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidLessThanOrEqualTo(String value) {
            addCriterion("CARTCOMPANYID_ <=", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidLike(String value) {
            addCriterion("CARTCOMPANYID_ like", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidNotLike(String value) {
            addCriterion("CARTCOMPANYID_ not like", value, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidIn(List<String> values) {
            addCriterion("CARTCOMPANYID_ in", values, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidNotIn(List<String> values) {
            addCriterion("CARTCOMPANYID_ not in", values, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidBetween(String value1, String value2) {
            addCriterion("CARTCOMPANYID_ between", value1, value2, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartcompanyidNotBetween(String value1, String value2) {
            addCriterion("CARTCOMPANYID_ not between", value1, value2, "cartcompanyid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidIsNull() {
            addCriterion("CARTACCOUNTID_ is null");
            return (Criteria) this;
        }

        public Criteria andCartaccountidIsNotNull() {
            addCriterion("CARTACCOUNTID_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartaccountidEqualTo(String value) {
            addCriterion("CARTACCOUNTID_ =", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidNotEqualTo(String value) {
            addCriterion("CARTACCOUNTID_ <>", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidGreaterThan(String value) {
            addCriterion("CARTACCOUNTID_ >", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidGreaterThanOrEqualTo(String value) {
            addCriterion("CARTACCOUNTID_ >=", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidLessThan(String value) {
            addCriterion("CARTACCOUNTID_ <", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidLessThanOrEqualTo(String value) {
            addCriterion("CARTACCOUNTID_ <=", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidLike(String value) {
            addCriterion("CARTACCOUNTID_ like", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidNotLike(String value) {
            addCriterion("CARTACCOUNTID_ not like", value, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidIn(List<String> values) {
            addCriterion("CARTACCOUNTID_ in", values, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidNotIn(List<String> values) {
            addCriterion("CARTACCOUNTID_ not in", values, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidBetween(String value1, String value2) {
            addCriterion("CARTACCOUNTID_ between", value1, value2, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartaccountidNotBetween(String value1, String value2) {
            addCriterion("CARTACCOUNTID_ not between", value1, value2, "cartaccountid");
            return (Criteria) this;
        }

        public Criteria andCartnumberIsNull() {
            addCriterion("CARTNUMBER_ is null");
            return (Criteria) this;
        }

        public Criteria andCartnumberIsNotNull() {
            addCriterion("CARTNUMBER_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartnumberEqualTo(BigDecimal value) {
            addCriterion("CARTNUMBER_ =", value, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberNotEqualTo(BigDecimal value) {
            addCriterion("CARTNUMBER_ <>", value, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberGreaterThan(BigDecimal value) {
            addCriterion("CARTNUMBER_ >", value, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARTNUMBER_ >=", value, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberLessThan(BigDecimal value) {
            addCriterion("CARTNUMBER_ <", value, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARTNUMBER_ <=", value, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberIn(List<BigDecimal> values) {
            addCriterion("CARTNUMBER_ in", values, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberNotIn(List<BigDecimal> values) {
            addCriterion("CARTNUMBER_ not in", values, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARTNUMBER_ between", value1, value2, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartnumberNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARTNUMBER_ not between", value1, value2, "cartnumber");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeIsNull() {
            addCriterion("CARTSHOPPINGTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeIsNotNull() {
            addCriterion("CARTSHOPPINGTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeEqualTo(BigDecimal value) {
            addCriterion("CARTSHOPPINGTIME_ =", value, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeNotEqualTo(BigDecimal value) {
            addCriterion("CARTSHOPPINGTIME_ <>", value, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeGreaterThan(BigDecimal value) {
            addCriterion("CARTSHOPPINGTIME_ >", value, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARTSHOPPINGTIME_ >=", value, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeLessThan(BigDecimal value) {
            addCriterion("CARTSHOPPINGTIME_ <", value, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARTSHOPPINGTIME_ <=", value, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeIn(List<BigDecimal> values) {
            addCriterion("CARTSHOPPINGTIME_ in", values, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeNotIn(List<BigDecimal> values) {
            addCriterion("CARTSHOPPINGTIME_ not in", values, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARTSHOPPINGTIME_ between", value1, value2, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartshoppingtimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARTSHOPPINGTIME_ not between", value1, value2, "cartshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeIsNull() {
            addCriterion("CARTSTRSHOPPINGTIME_ is null");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeIsNotNull() {
            addCriterion("CARTSTRSHOPPINGTIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeEqualTo(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ =", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeNotEqualTo(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ <>", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeGreaterThan(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ >", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeGreaterThanOrEqualTo(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ >=", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeLessThan(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ <", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeLessThanOrEqualTo(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ <=", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeLike(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ like", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeNotLike(String value) {
            addCriterion("CARTSTRSHOPPINGTIME_ not like", value, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeIn(List<String> values) {
            addCriterion("CARTSTRSHOPPINGTIME_ in", values, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeNotIn(List<String> values) {
            addCriterion("CARTSTRSHOPPINGTIME_ not in", values, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeBetween(String value1, String value2) {
            addCriterion("CARTSTRSHOPPINGTIME_ between", value1, value2, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartstrshoppingtimeNotBetween(String value1, String value2) {
            addCriterion("CARTSTRSHOPPINGTIME_ not between", value1, value2, "cartstrshoppingtime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeIsNull() {
            addCriterion("CARTUPDATETIME_ is null");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeIsNotNull() {
            addCriterion("CARTUPDATETIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeEqualTo(BigDecimal value) {
            addCriterion("CARTUPDATETIME_ =", value, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeNotEqualTo(BigDecimal value) {
            addCriterion("CARTUPDATETIME_ <>", value, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeGreaterThan(BigDecimal value) {
            addCriterion("CARTUPDATETIME_ >", value, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARTUPDATETIME_ >=", value, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeLessThan(BigDecimal value) {
            addCriterion("CARTUPDATETIME_ <", value, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARTUPDATETIME_ <=", value, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeIn(List<BigDecimal> values) {
            addCriterion("CARTUPDATETIME_ in", values, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeNotIn(List<BigDecimal> values) {
            addCriterion("CARTUPDATETIME_ not in", values, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARTUPDATETIME_ between", value1, value2, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartupdatetimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARTUPDATETIME_ not between", value1, value2, "cartupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeIsNull() {
            addCriterion("CARTSTRUPDATETIME_ is null");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeIsNotNull() {
            addCriterion("CARTSTRUPDATETIME_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeEqualTo(String value) {
            addCriterion("CARTSTRUPDATETIME_ =", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeNotEqualTo(String value) {
            addCriterion("CARTSTRUPDATETIME_ <>", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeGreaterThan(String value) {
            addCriterion("CARTSTRUPDATETIME_ >", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeGreaterThanOrEqualTo(String value) {
            addCriterion("CARTSTRUPDATETIME_ >=", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeLessThan(String value) {
            addCriterion("CARTSTRUPDATETIME_ <", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeLessThanOrEqualTo(String value) {
            addCriterion("CARTSTRUPDATETIME_ <=", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeLike(String value) {
            addCriterion("CARTSTRUPDATETIME_ like", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeNotLike(String value) {
            addCriterion("CARTSTRUPDATETIME_ not like", value, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeIn(List<String> values) {
            addCriterion("CARTSTRUPDATETIME_ in", values, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeNotIn(List<String> values) {
            addCriterion("CARTSTRUPDATETIME_ not in", values, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeBetween(String value1, String value2) {
            addCriterion("CARTSTRUPDATETIME_ between", value1, value2, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartstrupdatetimeNotBetween(String value1, String value2) {
            addCriterion("CARTSTRUPDATETIME_ not between", value1, value2, "cartstrupdatetime");
            return (Criteria) this;
        }

        public Criteria andCartattri1IsNull() {
            addCriterion("CARTATTRI1_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri1IsNotNull() {
            addCriterion("CARTATTRI1_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri1EqualTo(String value) {
            addCriterion("CARTATTRI1_ =", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1NotEqualTo(String value) {
            addCriterion("CARTATTRI1_ <>", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1GreaterThan(String value) {
            addCriterion("CARTATTRI1_ >", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI1_ >=", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1LessThan(String value) {
            addCriterion("CARTATTRI1_ <", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI1_ <=", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1Like(String value) {
            addCriterion("CARTATTRI1_ like", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1NotLike(String value) {
            addCriterion("CARTATTRI1_ not like", value, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1In(List<String> values) {
            addCriterion("CARTATTRI1_ in", values, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1NotIn(List<String> values) {
            addCriterion("CARTATTRI1_ not in", values, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1Between(String value1, String value2) {
            addCriterion("CARTATTRI1_ between", value1, value2, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri1NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI1_ not between", value1, value2, "cartattri1");
            return (Criteria) this;
        }

        public Criteria andCartattri2IsNull() {
            addCriterion("CARTATTRI2_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri2IsNotNull() {
            addCriterion("CARTATTRI2_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri2EqualTo(String value) {
            addCriterion("CARTATTRI2_ =", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2NotEqualTo(String value) {
            addCriterion("CARTATTRI2_ <>", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2GreaterThan(String value) {
            addCriterion("CARTATTRI2_ >", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI2_ >=", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2LessThan(String value) {
            addCriterion("CARTATTRI2_ <", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI2_ <=", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2Like(String value) {
            addCriterion("CARTATTRI2_ like", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2NotLike(String value) {
            addCriterion("CARTATTRI2_ not like", value, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2In(List<String> values) {
            addCriterion("CARTATTRI2_ in", values, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2NotIn(List<String> values) {
            addCriterion("CARTATTRI2_ not in", values, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2Between(String value1, String value2) {
            addCriterion("CARTATTRI2_ between", value1, value2, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri2NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI2_ not between", value1, value2, "cartattri2");
            return (Criteria) this;
        }

        public Criteria andCartattri3IsNull() {
            addCriterion("CARTATTRI3_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri3IsNotNull() {
            addCriterion("CARTATTRI3_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri3EqualTo(String value) {
            addCriterion("CARTATTRI3_ =", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3NotEqualTo(String value) {
            addCriterion("CARTATTRI3_ <>", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3GreaterThan(String value) {
            addCriterion("CARTATTRI3_ >", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI3_ >=", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3LessThan(String value) {
            addCriterion("CARTATTRI3_ <", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI3_ <=", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3Like(String value) {
            addCriterion("CARTATTRI3_ like", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3NotLike(String value) {
            addCriterion("CARTATTRI3_ not like", value, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3In(List<String> values) {
            addCriterion("CARTATTRI3_ in", values, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3NotIn(List<String> values) {
            addCriterion("CARTATTRI3_ not in", values, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3Between(String value1, String value2) {
            addCriterion("CARTATTRI3_ between", value1, value2, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri3NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI3_ not between", value1, value2, "cartattri3");
            return (Criteria) this;
        }

        public Criteria andCartattri4IsNull() {
            addCriterion("CARTATTRI4_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri4IsNotNull() {
            addCriterion("CARTATTRI4_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri4EqualTo(String value) {
            addCriterion("CARTATTRI4_ =", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4NotEqualTo(String value) {
            addCriterion("CARTATTRI4_ <>", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4GreaterThan(String value) {
            addCriterion("CARTATTRI4_ >", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI4_ >=", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4LessThan(String value) {
            addCriterion("CARTATTRI4_ <", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI4_ <=", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4Like(String value) {
            addCriterion("CARTATTRI4_ like", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4NotLike(String value) {
            addCriterion("CARTATTRI4_ not like", value, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4In(List<String> values) {
            addCriterion("CARTATTRI4_ in", values, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4NotIn(List<String> values) {
            addCriterion("CARTATTRI4_ not in", values, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4Between(String value1, String value2) {
            addCriterion("CARTATTRI4_ between", value1, value2, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri4NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI4_ not between", value1, value2, "cartattri4");
            return (Criteria) this;
        }

        public Criteria andCartattri5IsNull() {
            addCriterion("CARTATTRI5_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri5IsNotNull() {
            addCriterion("CARTATTRI5_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri5EqualTo(String value) {
            addCriterion("CARTATTRI5_ =", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5NotEqualTo(String value) {
            addCriterion("CARTATTRI5_ <>", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5GreaterThan(String value) {
            addCriterion("CARTATTRI5_ >", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI5_ >=", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5LessThan(String value) {
            addCriterion("CARTATTRI5_ <", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI5_ <=", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5Like(String value) {
            addCriterion("CARTATTRI5_ like", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5NotLike(String value) {
            addCriterion("CARTATTRI5_ not like", value, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5In(List<String> values) {
            addCriterion("CARTATTRI5_ in", values, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5NotIn(List<String> values) {
            addCriterion("CARTATTRI5_ not in", values, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5Between(String value1, String value2) {
            addCriterion("CARTATTRI5_ between", value1, value2, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri5NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI5_ not between", value1, value2, "cartattri5");
            return (Criteria) this;
        }

        public Criteria andCartattri6IsNull() {
            addCriterion("CARTATTRI6_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri6IsNotNull() {
            addCriterion("CARTATTRI6_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri6EqualTo(String value) {
            addCriterion("CARTATTRI6_ =", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6NotEqualTo(String value) {
            addCriterion("CARTATTRI6_ <>", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6GreaterThan(String value) {
            addCriterion("CARTATTRI6_ >", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI6_ >=", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6LessThan(String value) {
            addCriterion("CARTATTRI6_ <", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI6_ <=", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6Like(String value) {
            addCriterion("CARTATTRI6_ like", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6NotLike(String value) {
            addCriterion("CARTATTRI6_ not like", value, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6In(List<String> values) {
            addCriterion("CARTATTRI6_ in", values, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6NotIn(List<String> values) {
            addCriterion("CARTATTRI6_ not in", values, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6Between(String value1, String value2) {
            addCriterion("CARTATTRI6_ between", value1, value2, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri6NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI6_ not between", value1, value2, "cartattri6");
            return (Criteria) this;
        }

        public Criteria andCartattri7IsNull() {
            addCriterion("CARTATTRI7_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri7IsNotNull() {
            addCriterion("CARTATTRI7_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri7EqualTo(String value) {
            addCriterion("CARTATTRI7_ =", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7NotEqualTo(String value) {
            addCriterion("CARTATTRI7_ <>", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7GreaterThan(String value) {
            addCriterion("CARTATTRI7_ >", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI7_ >=", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7LessThan(String value) {
            addCriterion("CARTATTRI7_ <", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI7_ <=", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7Like(String value) {
            addCriterion("CARTATTRI7_ like", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7NotLike(String value) {
            addCriterion("CARTATTRI7_ not like", value, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7In(List<String> values) {
            addCriterion("CARTATTRI7_ in", values, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7NotIn(List<String> values) {
            addCriterion("CARTATTRI7_ not in", values, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7Between(String value1, String value2) {
            addCriterion("CARTATTRI7_ between", value1, value2, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri7NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI7_ not between", value1, value2, "cartattri7");
            return (Criteria) this;
        }

        public Criteria andCartattri8IsNull() {
            addCriterion("CARTATTRI8_ is null");
            return (Criteria) this;
        }

        public Criteria andCartattri8IsNotNull() {
            addCriterion("CARTATTRI8_ is not null");
            return (Criteria) this;
        }

        public Criteria andCartattri8EqualTo(String value) {
            addCriterion("CARTATTRI8_ =", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8NotEqualTo(String value) {
            addCriterion("CARTATTRI8_ <>", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8GreaterThan(String value) {
            addCriterion("CARTATTRI8_ >", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8GreaterThanOrEqualTo(String value) {
            addCriterion("CARTATTRI8_ >=", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8LessThan(String value) {
            addCriterion("CARTATTRI8_ <", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8LessThanOrEqualTo(String value) {
            addCriterion("CARTATTRI8_ <=", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8Like(String value) {
            addCriterion("CARTATTRI8_ like", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8NotLike(String value) {
            addCriterion("CARTATTRI8_ not like", value, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8In(List<String> values) {
            addCriterion("CARTATTRI8_ in", values, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8NotIn(List<String> values) {
            addCriterion("CARTATTRI8_ not in", values, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8Between(String value1, String value2) {
            addCriterion("CARTATTRI8_ between", value1, value2, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andCartattri8NotBetween(String value1, String value2) {
            addCriterion("CARTATTRI8_ not between", value1, value2, "cartattri8");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoIsNull() {
            addCriterion("PRODUCTPRODUCTINFO_ is null");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoIsNotNull() {
            addCriterion("PRODUCTPRODUCTINFO_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ =", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoNotEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ <>", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoGreaterThan(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ >", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ >=", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoLessThan(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ <", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ <=", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoLike(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ like", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoNotLike(String value) {
            addCriterion("PRODUCTPRODUCTINFO_ not like", value, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoIn(List<String> values) {
            addCriterion("PRODUCTPRODUCTINFO_ in", values, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoNotIn(List<String> values) {
            addCriterion("PRODUCTPRODUCTINFO_ not in", values, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoBetween(String value1, String value2) {
            addCriterion("PRODUCTPRODUCTINFO_ between", value1, value2, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductproductinfoNotBetween(String value1, String value2) {
            addCriterion("PRODUCTPRODUCTINFO_ not between", value1, value2, "productproductinfo");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathIsNull() {
            addCriterion("PRODUCTSMALLIMAGEPATH_ is null");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathIsNotNull() {
            addCriterion("PRODUCTSMALLIMAGEPATH_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathEqualTo(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ =", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathNotEqualTo(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ <>", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathGreaterThan(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ >", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ >=", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathLessThan(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ <", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ <=", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathLike(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ like", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathNotLike(String value) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ not like", value, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathIn(List<String> values) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ in", values, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathNotIn(List<String> values) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ not in", values, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathBetween(String value1, String value2) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ between", value1, value2, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductsmallimagepathNotBetween(String value1, String value2) {
            addCriterion("PRODUCTSMALLIMAGEPATH_ not between", value1, value2, "productsmallimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathIsNull() {
            addCriterion("PRODUCTPHONEIMAGEPATH_ is null");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathIsNotNull() {
            addCriterion("PRODUCTPHONEIMAGEPATH_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathEqualTo(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ =", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathNotEqualTo(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ <>", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathGreaterThan(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ >", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ >=", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathLessThan(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ <", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ <=", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathLike(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ like", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathNotLike(String value) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ not like", value, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathIn(List<String> values) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ in", values, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathNotIn(List<String> values) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ not in", values, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathBetween(String value1, String value2) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ between", value1, value2, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductphoneimagepathNotBetween(String value1, String value2) {
            addCriterion("PRODUCTPHONEIMAGEPATH_ not between", value1, value2, "productphoneimagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathIsNull() {
            addCriterion("PRODUCTMAXIMAGEPATH_ is null");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathIsNotNull() {
            addCriterion("PRODUCTMAXIMAGEPATH_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathEqualTo(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ =", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathNotEqualTo(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ <>", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathGreaterThan(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ >", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ >=", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathLessThan(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ <", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ <=", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathLike(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ like", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathNotLike(String value) {
            addCriterion("PRODUCTMAXIMAGEPATH_ not like", value, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathIn(List<String> values) {
            addCriterion("PRODUCTMAXIMAGEPATH_ in", values, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathNotIn(List<String> values) {
            addCriterion("PRODUCTMAXIMAGEPATH_ not in", values, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathBetween(String value1, String value2) {
            addCriterion("PRODUCTMAXIMAGEPATH_ between", value1, value2, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductmaximagepathNotBetween(String value1, String value2) {
            addCriterion("PRODUCTMAXIMAGEPATH_ not between", value1, value2, "productmaximagepath");
            return (Criteria) this;
        }

        public Criteria andProductfareIsNull() {
            addCriterion("PRODUCTFARE_ is null");
            return (Criteria) this;
        }

        public Criteria andProductfareIsNotNull() {
            addCriterion("PRODUCTFARE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductfareEqualTo(BigDecimal value) {
            addCriterion("PRODUCTFARE_ =", value, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareNotEqualTo(BigDecimal value) {
            addCriterion("PRODUCTFARE_ <>", value, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareGreaterThan(BigDecimal value) {
            addCriterion("PRODUCTFARE_ >", value, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PRODUCTFARE_ >=", value, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareLessThan(BigDecimal value) {
            addCriterion("PRODUCTFARE_ <", value, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PRODUCTFARE_ <=", value, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareIn(List<BigDecimal> values) {
            addCriterion("PRODUCTFARE_ in", values, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareNotIn(List<BigDecimal> values) {
            addCriterion("PRODUCTFARE_ not in", values, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRODUCTFARE_ between", value1, value2, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductfareNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRODUCTFARE_ not between", value1, value2, "productfare");
            return (Criteria) this;
        }

        public Criteria andProductoperationidIsNull() {
            addCriterion("PRODUCTOPERATIONID_ is null");
            return (Criteria) this;
        }

        public Criteria andProductoperationidIsNotNull() {
            addCriterion("PRODUCTOPERATIONID_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductoperationidEqualTo(String value) {
            addCriterion("PRODUCTOPERATIONID_ =", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidNotEqualTo(String value) {
            addCriterion("PRODUCTOPERATIONID_ <>", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidGreaterThan(String value) {
            addCriterion("PRODUCTOPERATIONID_ >", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTOPERATIONID_ >=", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidLessThan(String value) {
            addCriterion("PRODUCTOPERATIONID_ <", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTOPERATIONID_ <=", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidLike(String value) {
            addCriterion("PRODUCTOPERATIONID_ like", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidNotLike(String value) {
            addCriterion("PRODUCTOPERATIONID_ not like", value, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidIn(List<String> values) {
            addCriterion("PRODUCTOPERATIONID_ in", values, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidNotIn(List<String> values) {
            addCriterion("PRODUCTOPERATIONID_ not in", values, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidBetween(String value1, String value2) {
            addCriterion("PRODUCTOPERATIONID_ between", value1, value2, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductoperationidNotBetween(String value1, String value2) {
            addCriterion("PRODUCTOPERATIONID_ not between", value1, value2, "productoperationid");
            return (Criteria) this;
        }

        public Criteria andProductbriefIsNull() {
            addCriterion("PRODUCTBRIEF_ is null");
            return (Criteria) this;
        }

        public Criteria andProductbriefIsNotNull() {
            addCriterion("PRODUCTBRIEF_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductbriefEqualTo(String value) {
            addCriterion("PRODUCTBRIEF_ =", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefNotEqualTo(String value) {
            addCriterion("PRODUCTBRIEF_ <>", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefGreaterThan(String value) {
            addCriterion("PRODUCTBRIEF_ >", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTBRIEF_ >=", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefLessThan(String value) {
            addCriterion("PRODUCTBRIEF_ <", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTBRIEF_ <=", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefLike(String value) {
            addCriterion("PRODUCTBRIEF_ like", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefNotLike(String value) {
            addCriterion("PRODUCTBRIEF_ not like", value, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefIn(List<String> values) {
            addCriterion("PRODUCTBRIEF_ in", values, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefNotIn(List<String> values) {
            addCriterion("PRODUCTBRIEF_ not in", values, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefBetween(String value1, String value2) {
            addCriterion("PRODUCTBRIEF_ between", value1, value2, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductbriefNotBetween(String value1, String value2) {
            addCriterion("PRODUCTBRIEF_ not between", value1, value2, "productbrief");
            return (Criteria) this;
        }

        public Criteria andProductorderidIsNull() {
            addCriterion("PRODUCTORDERID_ is null");
            return (Criteria) this;
        }

        public Criteria andProductorderidIsNotNull() {
            addCriterion("PRODUCTORDERID_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductorderidEqualTo(BigDecimal value) {
            addCriterion("PRODUCTORDERID_ =", value, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidNotEqualTo(BigDecimal value) {
            addCriterion("PRODUCTORDERID_ <>", value, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidGreaterThan(BigDecimal value) {
            addCriterion("PRODUCTORDERID_ >", value, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PRODUCTORDERID_ >=", value, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidLessThan(BigDecimal value) {
            addCriterion("PRODUCTORDERID_ <", value, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PRODUCTORDERID_ <=", value, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidIn(List<BigDecimal> values) {
            addCriterion("PRODUCTORDERID_ in", values, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidNotIn(List<BigDecimal> values) {
            addCriterion("PRODUCTORDERID_ not in", values, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRODUCTORDERID_ between", value1, value2, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductorderidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRODUCTORDERID_ not between", value1, value2, "productorderid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidIsNull() {
            addCriterion("PRODUCTCOMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidIsNotNull() {
            addCriterion("PRODUCTCOMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidEqualTo(String value) {
            addCriterion("PRODUCTCOMPANYID_ =", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidNotEqualTo(String value) {
            addCriterion("PRODUCTCOMPANYID_ <>", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidGreaterThan(String value) {
            addCriterion("PRODUCTCOMPANYID_ >", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTCOMPANYID_ >=", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidLessThan(String value) {
            addCriterion("PRODUCTCOMPANYID_ <", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTCOMPANYID_ <=", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidLike(String value) {
            addCriterion("PRODUCTCOMPANYID_ like", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidNotLike(String value) {
            addCriterion("PRODUCTCOMPANYID_ not like", value, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidIn(List<String> values) {
            addCriterion("PRODUCTCOMPANYID_ in", values, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidNotIn(List<String> values) {
            addCriterion("PRODUCTCOMPANYID_ not in", values, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidBetween(String value1, String value2) {
            addCriterion("PRODUCTCOMPANYID_ between", value1, value2, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProductcompanyidNotBetween(String value1, String value2) {
            addCriterion("PRODUCTCOMPANYID_ not between", value1, value2, "productcompanyid");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeIsNull() {
            addCriterion("PRODUCTTGCORIGINALCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeIsNotNull() {
            addCriterion("PRODUCTTGCORIGINALCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeEqualTo(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ =", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeNotEqualTo(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ <>", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeGreaterThan(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ >", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ >=", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeLessThan(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ <", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ <=", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeLike(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ like", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeNotLike(String value) {
            addCriterion("PRODUCTTGCORIGINALCODE_ not like", value, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeIn(List<String> values) {
            addCriterion("PRODUCTTGCORIGINALCODE_ in", values, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeNotIn(List<String> values) {
            addCriterion("PRODUCTTGCORIGINALCODE_ not in", values, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeBetween(String value1, String value2) {
            addCriterion("PRODUCTTGCORIGINALCODE_ between", value1, value2, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProducttgcoriginalcodeNotBetween(String value1, String value2) {
            addCriterion("PRODUCTTGCORIGINALCODE_ not between", value1, value2, "producttgcoriginalcode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeIsNull() {
            addCriterion("PRODUCTPRODUCTMODE_ is null");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeIsNotNull() {
            addCriterion("PRODUCTPRODUCTMODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ =", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeNotEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ <>", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeGreaterThan(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ >", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ >=", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeLessThan(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ <", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ <=", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeLike(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ like", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeNotLike(String value) {
            addCriterion("PRODUCTPRODUCTMODE_ not like", value, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeIn(List<String> values) {
            addCriterion("PRODUCTPRODUCTMODE_ in", values, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeNotIn(List<String> values) {
            addCriterion("PRODUCTPRODUCTMODE_ not in", values, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeBetween(String value1, String value2) {
            addCriterion("PRODUCTPRODUCTMODE_ between", value1, value2, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductproductmodeNotBetween(String value1, String value2) {
            addCriterion("PRODUCTPRODUCTMODE_ not between", value1, value2, "productproductmode");
            return (Criteria) this;
        }

        public Criteria andProductordernumIsNull() {
            addCriterion("PRODUCTORDERNUM_ is null");
            return (Criteria) this;
        }

        public Criteria andProductordernumIsNotNull() {
            addCriterion("PRODUCTORDERNUM_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductordernumEqualTo(String value) {
            addCriterion("PRODUCTORDERNUM_ =", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumNotEqualTo(String value) {
            addCriterion("PRODUCTORDERNUM_ <>", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumGreaterThan(String value) {
            addCriterion("PRODUCTORDERNUM_ >", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTORDERNUM_ >=", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumLessThan(String value) {
            addCriterion("PRODUCTORDERNUM_ <", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTORDERNUM_ <=", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumLike(String value) {
            addCriterion("PRODUCTORDERNUM_ like", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumNotLike(String value) {
            addCriterion("PRODUCTORDERNUM_ not like", value, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumIn(List<String> values) {
            addCriterion("PRODUCTORDERNUM_ in", values, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumNotIn(List<String> values) {
            addCriterion("PRODUCTORDERNUM_ not in", values, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumBetween(String value1, String value2) {
            addCriterion("PRODUCTORDERNUM_ between", value1, value2, "productordernum");
            return (Criteria) this;
        }

        public Criteria andProductordernumNotBetween(String value1, String value2) {
            addCriterion("PRODUCTORDERNUM_ not between", value1, value2, "productordernum");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidIsNull() {
            addCriterion("DEALERCOMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidIsNotNull() {
            addCriterion("DEALERCOMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ =", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ <>", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidGreaterThan(String value) {
            addCriterion("DEALERCOMPANYID_ >", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ >=", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidLessThan(String value) {
            addCriterion("DEALERCOMPANYID_ <", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidLessThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYID_ <=", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidLike(String value) {
            addCriterion("DEALERCOMPANYID_ like", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotLike(String value) {
            addCriterion("DEALERCOMPANYID_ not like", value, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidIn(List<String> values) {
            addCriterion("DEALERCOMPANYID_ in", values, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotIn(List<String> values) {
            addCriterion("DEALERCOMPANYID_ not in", values, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYID_ between", value1, value2, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyidNotBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYID_ not between", value1, value2, "dealercompanyid");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameIsNull() {
            addCriterion("DEALERCOMPANYNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameIsNotNull() {
            addCriterion("DEALERCOMPANYNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ =", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ <>", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameGreaterThan(String value) {
            addCriterion("DEALERCOMPANYNAME_ >", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ >=", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameLessThan(String value) {
            addCriterion("DEALERCOMPANYNAME_ <", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameLessThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYNAME_ <=", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameLike(String value) {
            addCriterion("DEALERCOMPANYNAME_ like", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotLike(String value) {
            addCriterion("DEALERCOMPANYNAME_ not like", value, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameIn(List<String> values) {
            addCriterion("DEALERCOMPANYNAME_ in", values, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotIn(List<String> values) {
            addCriterion("DEALERCOMPANYNAME_ not in", values, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYNAME_ between", value1, value2, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanynameNotBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYNAME_ not between", value1, value2, "dealercompanyname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridIsNull() {
            addCriterion("DEALERCOMPANYOPERATORID_ is null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridIsNotNull() {
            addCriterion("DEALERCOMPANYOPERATORID_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ =", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridNotEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ <>", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridGreaterThan(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ >", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ >=", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridLessThan(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ <", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridLessThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ <=", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridLike(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ like", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridNotLike(String value) {
            addCriterion("DEALERCOMPANYOPERATORID_ not like", value, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridIn(List<String> values) {
            addCriterion("DEALERCOMPANYOPERATORID_ in", values, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridNotIn(List<String> values) {
            addCriterion("DEALERCOMPANYOPERATORID_ not in", values, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYOPERATORID_ between", value1, value2, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatoridNotBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYOPERATORID_ not between", value1, value2, "dealercompanyoperatorid");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameIsNull() {
            addCriterion("DEALERCOMPANYOPERATORNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameIsNotNull() {
            addCriterion("DEALERCOMPANYOPERATORNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ =", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameNotEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ <>", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameGreaterThan(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ >", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameGreaterThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ >=", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameLessThan(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ <", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameLessThanOrEqualTo(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ <=", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameLike(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ like", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameNotLike(String value) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ not like", value, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameIn(List<String> values) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ in", values, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameNotIn(List<String> values) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ not in", values, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ between", value1, value2, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andDealercompanyoperatornameNotBetween(String value1, String value2) {
            addCriterion("DEALERCOMPANYOPERATORNAME_ not between", value1, value2, "dealercompanyoperatorname");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusIsNull() {
            addCriterion("ORDERPROCESSINGSTATUS_ is null");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusIsNotNull() {
            addCriterion("ORDERPROCESSINGSTATUS_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusEqualTo(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ =", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusNotEqualTo(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ <>", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusGreaterThan(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ >", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ >=", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusLessThan(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ <", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusLessThanOrEqualTo(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ <=", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusLike(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ like", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusNotLike(String value) {
            addCriterion("ORDERPROCESSINGSTATUS_ not like", value, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusIn(List<String> values) {
            addCriterion("ORDERPROCESSINGSTATUS_ in", values, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusNotIn(List<String> values) {
            addCriterion("ORDERPROCESSINGSTATUS_ not in", values, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusBetween(String value1, String value2) {
            addCriterion("ORDERPROCESSINGSTATUS_ between", value1, value2, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingstatusNotBetween(String value1, String value2) {
            addCriterion("ORDERPROCESSINGSTATUS_ not between", value1, value2, "orderprocessingstatus");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescIsNull() {
            addCriterion("ORDERPROCESSINGDESC_ is null");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescIsNotNull() {
            addCriterion("ORDERPROCESSINGDESC_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescEqualTo(String value) {
            addCriterion("ORDERPROCESSINGDESC_ =", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescNotEqualTo(String value) {
            addCriterion("ORDERPROCESSINGDESC_ <>", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescGreaterThan(String value) {
            addCriterion("ORDERPROCESSINGDESC_ >", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERPROCESSINGDESC_ >=", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescLessThan(String value) {
            addCriterion("ORDERPROCESSINGDESC_ <", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescLessThanOrEqualTo(String value) {
            addCriterion("ORDERPROCESSINGDESC_ <=", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescLike(String value) {
            addCriterion("ORDERPROCESSINGDESC_ like", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescNotLike(String value) {
            addCriterion("ORDERPROCESSINGDESC_ not like", value, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescIn(List<String> values) {
            addCriterion("ORDERPROCESSINGDESC_ in", values, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescNotIn(List<String> values) {
            addCriterion("ORDERPROCESSINGDESC_ not in", values, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescBetween(String value1, String value2) {
            addCriterion("ORDERPROCESSINGDESC_ between", value1, value2, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andOrderprocessingdescNotBetween(String value1, String value2) {
            addCriterion("ORDERPROCESSINGDESC_ not between", value1, value2, "orderprocessingdesc");
            return (Criteria) this;
        }

        public Criteria andProductmodelIsNull() {
            addCriterion("PRODUCTMODEL_ is null");
            return (Criteria) this;
        }

        public Criteria andProductmodelIsNotNull() {
            addCriterion("PRODUCTMODEL_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductmodelEqualTo(String value) {
            addCriterion("PRODUCTMODEL_ =", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelNotEqualTo(String value) {
            addCriterion("PRODUCTMODEL_ <>", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelGreaterThan(String value) {
            addCriterion("PRODUCTMODEL_ >", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTMODEL_ >=", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelLessThan(String value) {
            addCriterion("PRODUCTMODEL_ <", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTMODEL_ <=", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelLike(String value) {
            addCriterion("PRODUCTMODEL_ like", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelNotLike(String value) {
            addCriterion("PRODUCTMODEL_ not like", value, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelIn(List<String> values) {
            addCriterion("PRODUCTMODEL_ in", values, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelNotIn(List<String> values) {
            addCriterion("PRODUCTMODEL_ not in", values, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelBetween(String value1, String value2) {
            addCriterion("PRODUCTMODEL_ between", value1, value2, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductmodelNotBetween(String value1, String value2) {
            addCriterion("PRODUCTMODEL_ not between", value1, value2, "productmodel");
            return (Criteria) this;
        }

        public Criteria andProductunitnameIsNull() {
            addCriterion("PRODUCTUNITNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andProductunitnameIsNotNull() {
            addCriterion("PRODUCTUNITNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductunitnameEqualTo(String value) {
            addCriterion("PRODUCTUNITNAME_ =", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameNotEqualTo(String value) {
            addCriterion("PRODUCTUNITNAME_ <>", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameGreaterThan(String value) {
            addCriterion("PRODUCTUNITNAME_ >", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTUNITNAME_ >=", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameLessThan(String value) {
            addCriterion("PRODUCTUNITNAME_ <", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTUNITNAME_ <=", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameLike(String value) {
            addCriterion("PRODUCTUNITNAME_ like", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameNotLike(String value) {
            addCriterion("PRODUCTUNITNAME_ not like", value, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameIn(List<String> values) {
            addCriterion("PRODUCTUNITNAME_ in", values, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameNotIn(List<String> values) {
            addCriterion("PRODUCTUNITNAME_ not in", values, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameBetween(String value1, String value2) {
            addCriterion("PRODUCTUNITNAME_ between", value1, value2, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductunitnameNotBetween(String value1, String value2) {
            addCriterion("PRODUCTUNITNAME_ not between", value1, value2, "productunitname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameIsNull() {
            addCriterion("PRODUCTCOLORNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andProductcolornameIsNotNull() {
            addCriterion("PRODUCTCOLORNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductcolornameEqualTo(String value) {
            addCriterion("PRODUCTCOLORNAME_ =", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameNotEqualTo(String value) {
            addCriterion("PRODUCTCOLORNAME_ <>", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameGreaterThan(String value) {
            addCriterion("PRODUCTCOLORNAME_ >", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTCOLORNAME_ >=", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameLessThan(String value) {
            addCriterion("PRODUCTCOLORNAME_ <", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTCOLORNAME_ <=", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameLike(String value) {
            addCriterion("PRODUCTCOLORNAME_ like", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameNotLike(String value) {
            addCriterion("PRODUCTCOLORNAME_ not like", value, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameIn(List<String> values) {
            addCriterion("PRODUCTCOLORNAME_ in", values, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameNotIn(List<String> values) {
            addCriterion("PRODUCTCOLORNAME_ not in", values, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameBetween(String value1, String value2) {
            addCriterion("PRODUCTCOLORNAME_ between", value1, value2, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductcolornameNotBetween(String value1, String value2) {
            addCriterion("PRODUCTCOLORNAME_ not between", value1, value2, "productcolorname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameIsNull() {
            addCriterion("PRODUCTPACKMATERIALNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameIsNotNull() {
            addCriterion("PRODUCTPACKMATERIALNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameEqualTo(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ =", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameNotEqualTo(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ <>", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameGreaterThan(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ >", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ >=", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameLessThan(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ <", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ <=", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameLike(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ like", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameNotLike(String value) {
            addCriterion("PRODUCTPACKMATERIALNAME_ not like", value, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameIn(List<String> values) {
            addCriterion("PRODUCTPACKMATERIALNAME_ in", values, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameNotIn(List<String> values) {
            addCriterion("PRODUCTPACKMATERIALNAME_ not in", values, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameBetween(String value1, String value2) {
            addCriterion("PRODUCTPACKMATERIALNAME_ between", value1, value2, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProductpackmaterialnameNotBetween(String value1, String value2) {
            addCriterion("PRODUCTPACKMATERIALNAME_ not between", value1, value2, "productpackmaterialname");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeIsNull() {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeIsNotNull() {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeEqualTo(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ =", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeNotEqualTo(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ <>", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeGreaterThan(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ >", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ >=", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeLessThan(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ <", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ <=", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeLike(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ like", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeNotLike(String value) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ not like", value, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeIn(List<String> values) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ in", values, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeNotIn(List<String> values) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ not in", values, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeBetween(String value1, String value2) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ between", value1, value2, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProducttgctwoclasscodeNotBetween(String value1, String value2) {
            addCriterion("PRODUCTTGCTWOCLASSCODE_ not between", value1, value2, "producttgctwoclasscode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeIsNull() {
            addCriterion("PRODUCTINTERNALCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeIsNotNull() {
            addCriterion("PRODUCTINTERNALCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeEqualTo(String value) {
            addCriterion("PRODUCTINTERNALCODE_ =", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeNotEqualTo(String value) {
            addCriterion("PRODUCTINTERNALCODE_ <>", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeGreaterThan(String value) {
            addCriterion("PRODUCTINTERNALCODE_ >", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTINTERNALCODE_ >=", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeLessThan(String value) {
            addCriterion("PRODUCTINTERNALCODE_ <", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTINTERNALCODE_ <=", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeLike(String value) {
            addCriterion("PRODUCTINTERNALCODE_ like", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeNotLike(String value) {
            addCriterion("PRODUCTINTERNALCODE_ not like", value, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeIn(List<String> values) {
            addCriterion("PRODUCTINTERNALCODE_ in", values, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeNotIn(List<String> values) {
            addCriterion("PRODUCTINTERNALCODE_ not in", values, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeBetween(String value1, String value2) {
            addCriterion("PRODUCTINTERNALCODE_ between", value1, value2, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andProductinternalcodeNotBetween(String value1, String value2) {
            addCriterion("PRODUCTINTERNALCODE_ not between", value1, value2, "productinternalcode");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNull() {
            addCriterion("ORDERNUM_ is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNotNull() {
            addCriterion("ORDERNUM_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumEqualTo(String value) {
            addCriterion("ORDERNUM_ =", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotEqualTo(String value) {
            addCriterion("ORDERNUM_ <>", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThan(String value) {
            addCriterion("ORDERNUM_ >", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERNUM_ >=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThan(String value) {
            addCriterion("ORDERNUM_ <", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThanOrEqualTo(String value) {
            addCriterion("ORDERNUM_ <=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLike(String value) {
            addCriterion("ORDERNUM_ like", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotLike(String value) {
            addCriterion("ORDERNUM_ not like", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumIn(List<String> values) {
            addCriterion("ORDERNUM_ in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotIn(List<String> values) {
            addCriterion("ORDERNUM_ not in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumBetween(String value1, String value2) {
            addCriterion("ORDERNUM_ between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotBetween(String value1, String value2) {
            addCriterion("ORDERNUM_ not between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andCompanyidIsNull() {
            addCriterion("COMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andCompanyidIsNotNull() {
            addCriterion("COMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyidEqualTo(String value) {
            addCriterion("COMPANYID_ =", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotEqualTo(String value) {
            addCriterion("COMPANYID_ <>", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidGreaterThan(String value) {
            addCriterion("COMPANYID_ >", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("COMPANYID_ >=", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLessThan(String value) {
            addCriterion("COMPANYID_ <", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLessThanOrEqualTo(String value) {
            addCriterion("COMPANYID_ <=", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLike(String value) {
            addCriterion("COMPANYID_ like", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotLike(String value) {
            addCriterion("COMPANYID_ not like", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidIn(List<String> values) {
            addCriterion("COMPANYID_ in", values, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotIn(List<String> values) {
            addCriterion("COMPANYID_ not in", values, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidBetween(String value1, String value2) {
            addCriterion("COMPANYID_ between", value1, value2, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotBetween(String value1, String value2) {
            addCriterion("COMPANYID_ not between", value1, value2, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanynameIsNull() {
            addCriterion("COMPANYNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andCompanynameIsNotNull() {
            addCriterion("COMPANYNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andCompanynameEqualTo(String value) {
            addCriterion("COMPANYNAME_ =", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameNotEqualTo(String value) {
            addCriterion("COMPANYNAME_ <>", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameGreaterThan(String value) {
            addCriterion("COMPANYNAME_ >", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameGreaterThanOrEqualTo(String value) {
            addCriterion("COMPANYNAME_ >=", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameLessThan(String value) {
            addCriterion("COMPANYNAME_ <", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameLessThanOrEqualTo(String value) {
            addCriterion("COMPANYNAME_ <=", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameLike(String value) {
            addCriterion("COMPANYNAME_ like", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameNotLike(String value) {
            addCriterion("COMPANYNAME_ not like", value, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameIn(List<String> values) {
            addCriterion("COMPANYNAME_ in", values, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameNotIn(List<String> values) {
            addCriterion("COMPANYNAME_ not in", values, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameBetween(String value1, String value2) {
            addCriterion("COMPANYNAME_ between", value1, value2, "companyname");
            return (Criteria) this;
        }

        public Criteria andCompanynameNotBetween(String value1, String value2) {
            addCriterion("COMPANYNAME_ not between", value1, value2, "companyname");
            return (Criteria) this;
        }

        public Criteria andProcessidIsNull() {
            addCriterion("PROCESSID_ is null");
            return (Criteria) this;
        }

        public Criteria andProcessidIsNotNull() {
            addCriterion("PROCESSID_ is not null");
            return (Criteria) this;
        }

        public Criteria andProcessidEqualTo(String value) {
            addCriterion("PROCESSID_ =", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidNotEqualTo(String value) {
            addCriterion("PROCESSID_ <>", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidGreaterThan(String value) {
            addCriterion("PROCESSID_ >", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidGreaterThanOrEqualTo(String value) {
            addCriterion("PROCESSID_ >=", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidLessThan(String value) {
            addCriterion("PROCESSID_ <", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidLessThanOrEqualTo(String value) {
            addCriterion("PROCESSID_ <=", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidLike(String value) {
            addCriterion("PROCESSID_ like", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidNotLike(String value) {
            addCriterion("PROCESSID_ not like", value, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidIn(List<String> values) {
            addCriterion("PROCESSID_ in", values, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidNotIn(List<String> values) {
            addCriterion("PROCESSID_ not in", values, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidBetween(String value1, String value2) {
            addCriterion("PROCESSID_ between", value1, value2, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessidNotBetween(String value1, String value2) {
            addCriterion("PROCESSID_ not between", value1, value2, "processid");
            return (Criteria) this;
        }

        public Criteria andProcessnameIsNull() {
            addCriterion("PROCESSNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andProcessnameIsNotNull() {
            addCriterion("PROCESSNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andProcessnameEqualTo(String value) {
            addCriterion("PROCESSNAME_ =", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameNotEqualTo(String value) {
            addCriterion("PROCESSNAME_ <>", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameGreaterThan(String value) {
            addCriterion("PROCESSNAME_ >", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameGreaterThanOrEqualTo(String value) {
            addCriterion("PROCESSNAME_ >=", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameLessThan(String value) {
            addCriterion("PROCESSNAME_ <", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameLessThanOrEqualTo(String value) {
            addCriterion("PROCESSNAME_ <=", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameLike(String value) {
            addCriterion("PROCESSNAME_ like", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameNotLike(String value) {
            addCriterion("PROCESSNAME_ not like", value, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameIn(List<String> values) {
            addCriterion("PROCESSNAME_ in", values, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameNotIn(List<String> values) {
            addCriterion("PROCESSNAME_ not in", values, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameBetween(String value1, String value2) {
            addCriterion("PROCESSNAME_ between", value1, value2, "processname");
            return (Criteria) this;
        }

        public Criteria andProcessnameNotBetween(String value1, String value2) {
            addCriterion("PROCESSNAME_ not between", value1, value2, "processname");
            return (Criteria) this;
        }

        public Criteria andProcesstypeIsNull() {
            addCriterion("PROCESSTYPE_ is null");
            return (Criteria) this;
        }

        public Criteria andProcesstypeIsNotNull() {
            addCriterion("PROCESSTYPE_ is not null");
            return (Criteria) this;
        }

        public Criteria andProcesstypeEqualTo(String value) {
            addCriterion("PROCESSTYPE_ =", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeNotEqualTo(String value) {
            addCriterion("PROCESSTYPE_ <>", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeGreaterThan(String value) {
            addCriterion("PROCESSTYPE_ >", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeGreaterThanOrEqualTo(String value) {
            addCriterion("PROCESSTYPE_ >=", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeLessThan(String value) {
            addCriterion("PROCESSTYPE_ <", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeLessThanOrEqualTo(String value) {
            addCriterion("PROCESSTYPE_ <=", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeLike(String value) {
            addCriterion("PROCESSTYPE_ like", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeNotLike(String value) {
            addCriterion("PROCESSTYPE_ not like", value, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeIn(List<String> values) {
            addCriterion("PROCESSTYPE_ in", values, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeNotIn(List<String> values) {
            addCriterion("PROCESSTYPE_ not in", values, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeBetween(String value1, String value2) {
            addCriterion("PROCESSTYPE_ between", value1, value2, "processtype");
            return (Criteria) this;
        }

        public Criteria andProcesstypeNotBetween(String value1, String value2) {
            addCriterion("PROCESSTYPE_ not between", value1, value2, "processtype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeIsNull() {
            addCriterion("STRPROCESSTYPE_ is null");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeIsNotNull() {
            addCriterion("STRPROCESSTYPE_ is not null");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeEqualTo(String value) {
            addCriterion("STRPROCESSTYPE_ =", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeNotEqualTo(String value) {
            addCriterion("STRPROCESSTYPE_ <>", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeGreaterThan(String value) {
            addCriterion("STRPROCESSTYPE_ >", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeGreaterThanOrEqualTo(String value) {
            addCriterion("STRPROCESSTYPE_ >=", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeLessThan(String value) {
            addCriterion("STRPROCESSTYPE_ <", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeLessThanOrEqualTo(String value) {
            addCriterion("STRPROCESSTYPE_ <=", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeLike(String value) {
            addCriterion("STRPROCESSTYPE_ like", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeNotLike(String value) {
            addCriterion("STRPROCESSTYPE_ not like", value, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeIn(List<String> values) {
            addCriterion("STRPROCESSTYPE_ in", values, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeNotIn(List<String> values) {
            addCriterion("STRPROCESSTYPE_ not in", values, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeBetween(String value1, String value2) {
            addCriterion("STRPROCESSTYPE_ between", value1, value2, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andStrprocesstypeNotBetween(String value1, String value2) {
            addCriterion("STRPROCESSTYPE_ not between", value1, value2, "strprocesstype");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidIsNull() {
            addCriterion("PUBCOMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidIsNotNull() {
            addCriterion("PUBCOMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidEqualTo(String value) {
            addCriterion("PUBCOMPANYID_ =", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidNotEqualTo(String value) {
            addCriterion("PUBCOMPANYID_ <>", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidGreaterThan(String value) {
            addCriterion("PUBCOMPANYID_ >", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("PUBCOMPANYID_ >=", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidLessThan(String value) {
            addCriterion("PUBCOMPANYID_ <", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidLessThanOrEqualTo(String value) {
            addCriterion("PUBCOMPANYID_ <=", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidLike(String value) {
            addCriterion("PUBCOMPANYID_ like", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidNotLike(String value) {
            addCriterion("PUBCOMPANYID_ not like", value, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidIn(List<String> values) {
            addCriterion("PUBCOMPANYID_ in", values, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidNotIn(List<String> values) {
            addCriterion("PUBCOMPANYID_ not in", values, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidBetween(String value1, String value2) {
            addCriterion("PUBCOMPANYID_ between", value1, value2, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanyidNotBetween(String value1, String value2) {
            addCriterion("PUBCOMPANYID_ not between", value1, value2, "pubcompanyid");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameIsNull() {
            addCriterion("PUBCOMPANYNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameIsNotNull() {
            addCriterion("PUBCOMPANYNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameEqualTo(String value) {
            addCriterion("PUBCOMPANYNAME_ =", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameNotEqualTo(String value) {
            addCriterion("PUBCOMPANYNAME_ <>", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameGreaterThan(String value) {
            addCriterion("PUBCOMPANYNAME_ >", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameGreaterThanOrEqualTo(String value) {
            addCriterion("PUBCOMPANYNAME_ >=", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameLessThan(String value) {
            addCriterion("PUBCOMPANYNAME_ <", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameLessThanOrEqualTo(String value) {
            addCriterion("PUBCOMPANYNAME_ <=", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameLike(String value) {
            addCriterion("PUBCOMPANYNAME_ like", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameNotLike(String value) {
            addCriterion("PUBCOMPANYNAME_ not like", value, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameIn(List<String> values) {
            addCriterion("PUBCOMPANYNAME_ in", values, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameNotIn(List<String> values) {
            addCriterion("PUBCOMPANYNAME_ not in", values, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameBetween(String value1, String value2) {
            addCriterion("PUBCOMPANYNAME_ between", value1, value2, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andPubcompanynameNotBetween(String value1, String value2) {
            addCriterion("PUBCOMPANYNAME_ not between", value1, value2, "pubcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNull() {
            addCriterion("ACCOUNTID_ is null");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNotNull() {
            addCriterion("ACCOUNTID_ is not null");
            return (Criteria) this;
        }

        public Criteria andAccountidEqualTo(String value) {
            addCriterion("ACCOUNTID_ =", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotEqualTo(String value) {
            addCriterion("ACCOUNTID_ <>", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThan(String value) {
            addCriterion("ACCOUNTID_ >", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThanOrEqualTo(String value) {
            addCriterion("ACCOUNTID_ >=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThan(String value) {
            addCriterion("ACCOUNTID_ <", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThanOrEqualTo(String value) {
            addCriterion("ACCOUNTID_ <=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLike(String value) {
            addCriterion("ACCOUNTID_ like", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotLike(String value) {
            addCriterion("ACCOUNTID_ not like", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidIn(List<String> values) {
            addCriterion("ACCOUNTID_ in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotIn(List<String> values) {
            addCriterion("ACCOUNTID_ not in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidBetween(String value1, String value2) {
            addCriterion("ACCOUNTID_ between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotBetween(String value1, String value2) {
            addCriterion("ACCOUNTID_ not between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountnameIsNull() {
            addCriterion("ACCOUNTNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andAccountnameIsNotNull() {
            addCriterion("ACCOUNTNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andAccountnameEqualTo(String value) {
            addCriterion("ACCOUNTNAME_ =", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotEqualTo(String value) {
            addCriterion("ACCOUNTNAME_ <>", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameGreaterThan(String value) {
            addCriterion("ACCOUNTNAME_ >", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameGreaterThanOrEqualTo(String value) {
            addCriterion("ACCOUNTNAME_ >=", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLessThan(String value) {
            addCriterion("ACCOUNTNAME_ <", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLessThanOrEqualTo(String value) {
            addCriterion("ACCOUNTNAME_ <=", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLike(String value) {
            addCriterion("ACCOUNTNAME_ like", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotLike(String value) {
            addCriterion("ACCOUNTNAME_ not like", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameIn(List<String> values) {
            addCriterion("ACCOUNTNAME_ in", values, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotIn(List<String> values) {
            addCriterion("ACCOUNTNAME_ not in", values, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameBetween(String value1, String value2) {
            addCriterion("ACCOUNTNAME_ between", value1, value2, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotBetween(String value1, String value2) {
            addCriterion("ACCOUNTNAME_ not between", value1, value2, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidIsNull() {
            addCriterion("ACCOUNTCOMPANYID_ is null");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidIsNotNull() {
            addCriterion("ACCOUNTCOMPANYID_ is not null");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYID_ =", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidNotEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYID_ <>", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidGreaterThan(String value) {
            addCriterion("ACCOUNTCOMPANYID_ >", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidGreaterThanOrEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYID_ >=", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidLessThan(String value) {
            addCriterion("ACCOUNTCOMPANYID_ <", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidLessThanOrEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYID_ <=", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidLike(String value) {
            addCriterion("ACCOUNTCOMPANYID_ like", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidNotLike(String value) {
            addCriterion("ACCOUNTCOMPANYID_ not like", value, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidIn(List<String> values) {
            addCriterion("ACCOUNTCOMPANYID_ in", values, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidNotIn(List<String> values) {
            addCriterion("ACCOUNTCOMPANYID_ not in", values, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidBetween(String value1, String value2) {
            addCriterion("ACCOUNTCOMPANYID_ between", value1, value2, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanyidNotBetween(String value1, String value2) {
            addCriterion("ACCOUNTCOMPANYID_ not between", value1, value2, "accountcompanyid");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameIsNull() {
            addCriterion("ACCOUNTCOMPANYNAME_ is null");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameIsNotNull() {
            addCriterion("ACCOUNTCOMPANYNAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ =", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameNotEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ <>", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameGreaterThan(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ >", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameGreaterThanOrEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ >=", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameLessThan(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ <", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameLessThanOrEqualTo(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ <=", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameLike(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ like", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameNotLike(String value) {
            addCriterion("ACCOUNTCOMPANYNAME_ not like", value, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameIn(List<String> values) {
            addCriterion("ACCOUNTCOMPANYNAME_ in", values, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameNotIn(List<String> values) {
            addCriterion("ACCOUNTCOMPANYNAME_ not in", values, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameBetween(String value1, String value2) {
            addCriterion("ACCOUNTCOMPANYNAME_ between", value1, value2, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andAccountcompanynameNotBetween(String value1, String value2) {
            addCriterion("ACCOUNTCOMPANYNAME_ not between", value1, value2, "accountcompanyname");
            return (Criteria) this;
        }

        public Criteria andOrderincomeIsNull() {
            addCriterion("ORDERINCOME is null");
            return (Criteria) this;
        }

        public Criteria andOrderincomeIsNotNull() {
            addCriterion("ORDERINCOME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderincomeEqualTo(BigDecimal value) {
            addCriterion("ORDERINCOME =", value, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeNotEqualTo(BigDecimal value) {
            addCriterion("ORDERINCOME <>", value, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeGreaterThan(BigDecimal value) {
            addCriterion("ORDERINCOME >", value, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERINCOME >=", value, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeLessThan(BigDecimal value) {
            addCriterion("ORDERINCOME <", value, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERINCOME <=", value, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeIn(List<BigDecimal> values) {
            addCriterion("ORDERINCOME in", values, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeNotIn(List<BigDecimal> values) {
            addCriterion("ORDERINCOME not in", values, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERINCOME between", value1, value2, "orderincome");
            return (Criteria) this;
        }

        public Criteria andOrderincomeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERINCOME not between", value1, value2, "orderincome");
            return (Criteria) this;
        }

        public Criteria andHongbaoIsNull() {
            addCriterion("HONGBAO_ is null");
            return (Criteria) this;
        }

        public Criteria andHongbaoIsNotNull() {
            addCriterion("HONGBAO_ is not null");
            return (Criteria) this;
        }

        public Criteria andHongbaoEqualTo(BigDecimal value) {
            addCriterion("HONGBAO_ =", value, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoNotEqualTo(BigDecimal value) {
            addCriterion("HONGBAO_ <>", value, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoGreaterThan(BigDecimal value) {
            addCriterion("HONGBAO_ >", value, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HONGBAO_ >=", value, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoLessThan(BigDecimal value) {
            addCriterion("HONGBAO_ <", value, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HONGBAO_ <=", value, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoIn(List<BigDecimal> values) {
            addCriterion("HONGBAO_ in", values, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoNotIn(List<BigDecimal> values) {
            addCriterion("HONGBAO_ not in", values, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HONGBAO_ between", value1, value2, "hongbao");
            return (Criteria) this;
        }

        public Criteria andHongbaoNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HONGBAO_ not between", value1, value2, "hongbao");
            return (Criteria) this;
        }

        public Criteria andChannelnumberIsNull() {
            addCriterion("CHANNELNUMBER is null");
            return (Criteria) this;
        }

        public Criteria andChannelnumberIsNotNull() {
            addCriterion("CHANNELNUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andChannelnumberEqualTo(String value) {
            addCriterion("CHANNELNUMBER =", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberNotEqualTo(String value) {
            addCriterion("CHANNELNUMBER <>", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberGreaterThan(String value) {
            addCriterion("CHANNELNUMBER >", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNELNUMBER >=", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberLessThan(String value) {
            addCriterion("CHANNELNUMBER <", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberLessThanOrEqualTo(String value) {
            addCriterion("CHANNELNUMBER <=", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberLike(String value) {
            addCriterion("CHANNELNUMBER like", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberNotLike(String value) {
            addCriterion("CHANNELNUMBER not like", value, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberIn(List<String> values) {
            addCriterion("CHANNELNUMBER in", values, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberNotIn(List<String> values) {
            addCriterion("CHANNELNUMBER not in", values, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberBetween(String value1, String value2) {
            addCriterion("CHANNELNUMBER between", value1, value2, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andChannelnumberNotBetween(String value1, String value2) {
            addCriterion("CHANNELNUMBER not between", value1, value2, "channelnumber");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusIsNull() {
            addCriterion("AFTERSALESTUTUS is null");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusIsNotNull() {
            addCriterion("AFTERSALESTUTUS is not null");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusEqualTo(String value) {
            addCriterion("AFTERSALESTUTUS =", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusNotEqualTo(String value) {
            addCriterion("AFTERSALESTUTUS <>", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusGreaterThan(String value) {
            addCriterion("AFTERSALESTUTUS >", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusGreaterThanOrEqualTo(String value) {
            addCriterion("AFTERSALESTUTUS >=", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusLessThan(String value) {
            addCriterion("AFTERSALESTUTUS <", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusLessThanOrEqualTo(String value) {
            addCriterion("AFTERSALESTUTUS <=", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusLike(String value) {
            addCriterion("AFTERSALESTUTUS like", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusNotLike(String value) {
            addCriterion("AFTERSALESTUTUS not like", value, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusIn(List<String> values) {
            addCriterion("AFTERSALESTUTUS in", values, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusNotIn(List<String> values) {
            addCriterion("AFTERSALESTUTUS not in", values, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusBetween(String value1, String value2) {
            addCriterion("AFTERSALESTUTUS between", value1, value2, "aftersalestutus");
            return (Criteria) this;
        }

        public Criteria andAftersalestutusNotBetween(String value1, String value2) {
            addCriterion("AFTERSALESTUTUS not between", value1, value2, "aftersalestutus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}